﻿IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_HO_SO_THAM_DINH_Restore]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sproc_HO_SO_THAM_DINH_Restore]
GO
 
CREATE PROCEDURE [dbo].sproc_HO_SO_THAM_DINH_Restore
	@MA_HO_SO BIGINT
AS
BEGIN
	UPDATE HO_SO_THAM_DINH
	SET
		ACTIVE_FLAG = 'T'
	WHERE MA_HO_SO = @MA_HO_SO
	
	SELECT 1
END
GO
